# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# SQL constraint on fields:        [sseq =927490]
# Order by:                        seq
# Description of each column
# seq: ----------------- Sequence number
# $link[objname]: ------ Designation of the object
# date: ---------------- Observation date
# $link[slen]: --------- Length of the series
# mask: ---------------- Name of the mask
# ccf_offline: --------- Offline CCF
# $field[rv]: ---------- Radial velocity
# fwhm: ---------------- FWHM of the correlation peak
# span: ---------------- Bissector span
# maxcpp: -------------- Maximum number of counts per pixel
# contrast: ------------ Contrast of the CCF
# lines: --------------- Number of lines used for the CCF
# $link['view_head']: -- See the header of the cross-correlation file
# $link['get_ccf']: ---- Download the cross-correlation function FITS file
# $link['view_ccf']: --- View the cross-correlation function
#-------------- ------- --------------- ---- -- --------------- ---------------- -------- ------- --------------- ------ --------------- ----------- --------- ----------
#seq    $link[o date            $lin ma c $field[rv]       fwhm     span    maxcpp  contra l $link['view $link['ge $link['vie
#       bjname]                 k[sl sk c                                           st     i _head']     t_ccf']   w_ccf']   
#                               en]     f                                                  n                                 
#                                       _                                                  e                                 
#                                       o                                                  s                                 
#                                       f                                                                                    
#                                       f                                                                                    
#                                       l                                                                                    
#                                       i                                                                                    
#                                       n                                                                                    
#                                       e                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
 927490 HD028307 2010-09-24   20 K5 0  42.559  0.0009     8.307   0.040    5162  38.96 6980 view_head   get_ccf   view_ccf  
 927500 HD028307 2010-09-24   20 K5 0  42.557  0.0009     8.290   0.040    4804  38.98 6980 view_head   get_ccf   view_ccf  
 927510 HD028307 2010-09-24   20 K5 0  42.561  0.0010     8.282   0.042    4196  38.89 6980 view_head   get_ccf   view_ccf  
 927520 HD028307 2010-09-24   20 K5 0  42.558  0.0011     8.288   0.036    3880  38.80 6980 view_head   get_ccf   view_ccf  
 927530 HD028307 2010-09-24   20 K5 0  42.558  0.0010     8.285   0.039    4198  38.90 6980 view_head   get_ccf   view_ccf  
 927540 HD028307 2010-09-24   20 K5 0  42.559  0.0010     8.290   0.040    4158  38.85 6980 view_head   get_ccf   view_ccf  
 927550 HD028307 2010-09-24   20 K5 0  42.559  0.0010     8.285   0.039    4121  38.88 6980 view_head   get_ccf   view_ccf  
 927561 HD028307 2010-09-24   20 K5 0  42.559  0.0011     8.282   0.037    3722  38.75 6980 view_head   get_ccf   view_ccf  
 927571 HD028307 2010-09-24   20 K5 0  42.560  0.0010     8.278   0.038    4359  38.94 6980 view_head   get_ccf   view_ccf  
 927581 HD028307 2010-09-24   20 K5 0  42.561  0.0010     8.286   0.045    4125  38.86 6980 view_head   get_ccf   view_ccf  
 927591 HD028307 2010-09-24   20 K5 0  42.558  0.0010     8.275   0.038    4083  38.92 6980 view_head   get_ccf   view_ccf  
 927601 HD028307 2010-09-24   20 K5 0  42.561  0.0010     8.276   0.040    4270  38.96 6980 view_head   get_ccf   view_ccf  
 927610 HD028307 2010-09-24   20 K5 0  42.560  0.0010     8.277   0.038    3993  38.90 6980 view_head   get_ccf   view_ccf  
 927621 HD028307 2010-09-24   20 K5 0  42.561  0.0010     8.277   0.042    4102  38.91 6980 view_head   get_ccf   view_ccf  
 927630 HD028307 2010-09-24   20 K5 0  42.560  0.0010     8.278   0.041    4128  38.92 6980 view_head   get_ccf   view_ccf  
 927641 HD028307 2010-09-24   20 K5 0  42.558  0.0010     8.278   0.038    4259  38.94 6980 view_head   get_ccf   view_ccf  
 927651 HD028307 2010-09-24   20 K5 0  42.556  0.0011     8.266   0.045    3917  38.93 6980 view_head   get_ccf   view_ccf  
 927661 HD028307 2010-09-24   20 K5 0  42.555  0.0011     8.267   0.041    3735  38.89 6980 view_head   get_ccf   view_ccf  
 927671 HD028307 2010-09-24   20 K5 0  42.556  0.0011     8.264   0.038    3653  38.87 6980 view_head   get_ccf   view_ccf  
 927681 HD028307 2010-09-24   20 K5 0  42.559  0.0011     8.268   0.039    3942  38.91 6980 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved